Field Name values for barcodes

Inventory fields

The following table defines the Field Name options when you are creating your barcode label printer defaults. The Available for... column indicates if that Field Name is available for barcodes for SA inventory, Titles inventory, or both. The Description column describes where the information for that Field Name is found in AIMsi.

Field name Available for... Description
  SA Titles  

Arranger

 

Y

Arranger box on the Enter New Catalog window, Description tab.

Artist

 

Y

Artist box on the Enter New Catalog window, Description tab.

Catalog Notes

 

Y

Notes box on the Enter New Catalog window, Description tab.

Catalog#

 

Y

Catalog box on the Enter New Catalog window, Description tab.

Category

Y

Y

SA inventory Category box on the following windows, depending on how the item was received into inventory:

Titles inventory Category box on the Enter New Catalog window, Description tab.

Color

Y

 

Color box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Composer

 

Y

Composer box on the Enter New Catalog window, Description tab.

Consign Acct

Y

 

Consignor account selected when the consignment was entered.

Consign Discount Date 1-4

Y

 

Based on the date the consignment was entered into inventory and the discounts set up on the Consignment Discounts window.

Consign Discount Price 1-4

Y

 

Based on the price of the consigned item when it was entered into inventory and the discounts set up on the Consignment Discounts window.

Cost Code

Y

Y

A combination of the last received date and cost of the item using the following format: MMDD#CCYY (where MM is the month of the last received date, DD is the dollars, CC is the cents, and YY is the year). For example, 0335#6913 means the item was last received in March of 2013 and the cost is $35.69.

Date Received

Y

Y

The most recent date the item was received.

Description

Y

 

Desc box on the following windows, depending on how the inventory was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Encrypted Date

Y

Y

A combination of the month and year the date was received in the following format: Y1MY2 (where Y1 is the first number of the year, M is the alphabetic equivalent of the numeric month, and Y2 is the second number in the year). For example, if the item was received in March of 2013, the encrypted date is 1C3 (C is the 3rd letter of the alphabet and March is the 3rd month).

Inventory Number

Y

Y

SA inventory Barcode box on the Enter New Inventory window, Description tab.

Titles inventory Barcode box on the Enter New Catalog window, Description tab.

Inventory Source

Y

 

C = Consignment

B = Inventory Purchase from Customer

I = Trade-In

Lease Code

Y

 

Lease Pool check box (True or False) on the SA Inventory Maintenance window, Serial Info tab.

Level

 

Y

Level box on the Enter New Catalog window, Description tab.

Location

Y

Y

SA inventory Loc or Location box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Matrix tab.
  • Enter Consignment (Batch Mode) window.
  • Enter Purchase (Batch Mode) window.

Titles inventory Loc box on the Enter New Catalog window, Description tab.

Locator

Y

Y

SA inventory Locator box on the Enter New Inventory window, Description tab.

Titles inventory Locator box on the Enter New Catalog window, Description tab.

Manufacturer

Y

 

Mfg box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Enter Consignment (Batch Mode) window.
  • Enter Purchase (Batch Mode) window.

Minimum Price

 

Y

Min box on the Enter New Catalog window, Description tab.

Minimum Retail

Y

 

Min box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Model

Y

 

Model box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

New/Used Code

Y

 

Code box on the SA Inventory Maintenance window, Serial Info tab.

OurPrice

Y

Y

SA inventory Ourprice box on the following windows depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Titles inventory Ourprice box on the Enter New Catalog window, Description tab.

OurPrice + Tax

Y

Y

The Ourprice value plus the tax rate for your location.

Price Code A - C

Y

Y

An encrypted price using the following format: PP$$$$SS, where $$$$ is the price of the item, including cents, in reverse. For example, if the price of the item is $3.25, the price code is PP523SS. If the price of the item is $850.00, the price code is PP00058SS.

PriceA-PriceC

Y

Y

SA inventory Price A, Price B, and Price C values for the item from the Enter New Inventory window, Description tab.

Titles inventory Price A, Price B, and Price C values for the item from the Enter New Catalog window, Description tab.

Publisher

 

Y

Publisher box on the Enter New Catalog window, Description tab.

Rental Income

Y

 

Contract Amt box on the SA Inventory Maintenance window, Serial Info tab. This is the amount of rental income collected over time for this item.

Retail

Y

Y

SA inventory Retail box on the following windows depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Titles inventory Retail box on the Enter New Catalog window, Description tab.

Sales Price

Y

Y

Based on any parameters you have set up for your sale on the Establish Upcoming Sale Parameters window.

Selcode Description

Y

Y

Description box on the Enter Selection Codes window for the selection code associated with the item.

Selection Code

Y

Y

SA inventory Sel Code box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Item Details window when entering consignments or purchases in batch mode.

Titles inventory Sel Code box on the Enter New Catalog window, Description tab.

Serial# Notes

Y

 

Left Notes box at the bottom of the SA Inventory Maintenance window, Serial Info tab.

Size

Y

 

Size box on the Enter New Inventory window, Description tab.

Sku Notes

Y

 

Notes box (Notes selected) on the SA Inventory Maintenance window, Description Info tab.

Sku#

Y

 

Sku box on the Enter New Inventory window, Description tab.

Stock#

Y

 

Stock# box on the SA Inventory Maintenance window, Serial Info tab.

Sub Category

Y

 

Sub Cat box on the following windows, depending on how the item was received into inventory:

  • Enter New Inventory window, Description tab.
  • Enter Consignment (Batch Mode) window.
  • Enter Purchase (Batch Mode) window.

Tax on OurPrice

Y

Y

Amount of tax, based on your location, to apply to the item based on its Ourprice value.

Type Your Own Text

Y

Y

Enter any text to print on the label, such as your store name.

Units

Y

 

Unit box on the SA Inventory Maintenance window, Description Info tab.

Vendor

Y

Y

SA inventory Prim Vend box on the Enter New Inventory window, Description tab.

Titles inventory Prim Vend box on the Enter New Catalog window, Description tab.

Voicing

 

Y

Voicing box on the Enter New Catalog window, Description tab.

Warranty Months

Y

 

Warranty box on the Enter New Inventory window, Description tab.